Look Up Range
AutomatR.Excel.Activities.LookUpRange
The "Look Up Range" activity in AutomatR is part of the Excel activities package, designed to search for a specified value within a given range in Microsoft Excel. This activity returns the coordinates of the cell containing the searched value as string variables, enhancing automation capabilities in Excel workflows.
Properties
| Name | Description |
|---|---|
| Input | |
| Range | Enter the range to be searched. String variables containing the range in Excel format (e.g., "A1:B10"). |
| Value | Enter the value to search within the specified range. String variables containing the value to be searched. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Enter the wait time in seconds (Example 5 seconds, i.e., 5) to start the activity. Integer variables containing the delay duration. |
| Output | |
| Result | Return the cell number containing the searched value. String variables representing the cell coordinates (e.g., "B3"). |
How to use:
- Drag and drop the "Look Up Range" activity onto the workflow.
- Configure the properties by specifying the range to be searched and the value to look up within that range.
- Optionally, configure the delay.
- Execute the workflow to search for the specified value within the given range in Excel.
Example: Consider an example where the "Look Up Range" activity is used to find the cell containing the value "John" within the range "A1:B10":
Look Up Range:
Range: "A1:B10"
Value: "John"
Delay: 2
In this example, the activity searches for the value "John" within the range "A1:B10" with a delay of 2 seconds. The result, representing the cell coordinates containing the searched value, is stored in the string variable specified in the "Result" property.
Note: Ensure that the "Look Up Range" activity is placed within an "Excel Root" activity to establish the Excel context for execution.